hive -e '

use credit;

CREATE TABLE if not exists ods_cust_info(
    cust_id string,
    cust_name string,
    product_code INT,
    txt_amt INT,
    addrno INT,
    age INT,
    dt string
) row format delimited fields terminated by ","
location "/warehouse/credit/ods/ods_cust_info";

CREATE TABLE if not exists  ods_addr_info (
    addrno INT,
    addrname string,
    addrcode string
)row format delimited fields terminated by ","
location "/warehouse/credit/ods/ods_addr_info";

CREATE TABLE if not exists  ods_product_info (
    product_code INT,
    product_name string,
    product_type string
)row format delimited fields terminated by ","
location "/warehouse/credit/ods/ods_product_info";


'
